Overview
Brought to you by YData
Dataset statistics
| Number of variables | 33 |
|---|---|
| Number of observations | 10324 |
| Missing cells | 2383 |
| Missing cells (%) | 0.7% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.5 MiB |
| Average record size in memory | 257.0 B |
Variable types
| Numeric | 7 |
|---|---|
| Text | 13 |
| Categorical | 9 |
| DateTime | 3 |
| Boolean | 1 |
line item quantity is highly overall correlated with line item insurance (usd) and 1 other fields | High correlation |
line item value is highly overall correlated with line item insurance (usd) and 1 other fields | High correlation |
line item insurance (usd) is highly overall correlated with line item quantity and 1 other fields | High correlation |
pack price is highly overall correlated with brand and 1 other fields | High correlation |
unit price is highly overall correlated with brand and 1 other fields | High correlation |
brand is highly overall correlated with dosage form and 6 other fields | High correlation |
country is highly overall correlated with fulfill via and 1 other fields | High correlation |
dosage form is highly overall correlated with brand and 3 other fields | High correlation |
fulfill via is highly overall correlated with brand and 3 other fields | High correlation |
id is highly overall correlated with fulfill via | High correlation |
product group is highly overall correlated with brand and 3 other fields | High correlation |
shipment mode is highly overall correlated with country | High correlation |
sub classification is highly overall correlated with brand and 3 other fields | High correlation |
unit of measure (per pack) is highly overall correlated with brand and 3 other fields | High correlation |
vendor inco term is highly overall correlated with fulfill via | High correlation |
managed by is highly imbalanced (97.4%) | Imbalance |
product group is highly imbalanced (69.9%) | Imbalance |
brand is highly imbalanced (62.3%) | Imbalance |
shipment mode has 360 (3.5%) missing values | Missing |
dosage has 1736 (16.8%) missing values | Missing |
line item insurance (usd) has 287 (2.8%) missing values | Missing |
unit price is highly skewed (γ1 = 40.58484939) | Skewed |
id has unique values | Unique |
Reproduction
| Analysis started | 2024-12-30 16:45:29.391489 |
|---|---|
| Analysis finished | 2024-12-30 16:45:55.755549 |
| Duration | 26.36 seconds |
| Software version | ydata-profiling vv4.12.1 |
| Download configuration | config.json |
Variables
id
Real number (ℝ)
High correlation  Unique 
| Distinct | 10324 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 51098.968 |
| Minimum | 1 |
|---|---|
| Maximum | 86823 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 80.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5151.2 |
| Q1 | 12795.75 |
| median | 57540.5 |
| Q3 | 83648.25 |
| 95-th percentile | 86167.85 |
| Maximum | 86823 |
| Range | 86822 |
| Interquartile range (IQR) | 70852.5 |
Descriptive statistics
| Standard deviation | 31944.332 |
|---|---|
| Coefficient of variation (CV) | 0.62514633 |
| Kurtosis | -1.6398372 |
| Mean | 51098.968 |
| Median Absolute Deviation (MAD) | 27404 |
| Skewness | -0.23036671 |
| Sum | 5.2754575 × 108 |
| Variance | 1.0204404 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 82565 | 1 | < 0.1% |
| 82594 | 1 | < 0.1% |
| 82595 | 1 | < 0.1% |
| 82596 | 1 | < 0.1% |
| 82597 | 1 | < 0.1% |
| 82599 | 1 | < 0.1% |
| 82600 | 1 | < 0.1% |
| 82601 | 1 | < 0.1% |
| 82602 | 1 | < 0.1% |
| Other values (10314) | 10314 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 15 | 1 | |
| 16 | 1 | |
| 23 | 1 | |
| 44 | 1 | |
| 45 | 1 | |
| 46 | 1 | |
| 47 | 1 |
| Value | Count | Frequency (%) |
| 86823 | 1 | |
| 86822 | 1 | |
| 86821 | 1 | |
| 86819 | 1 | |
| 86818 | 1 | |
| 86817 | 1 | |
| 86816 | 1 | |
| 86815 | 1 | |
| 86814 | 1 | |
| 86813 | 1 |
project code
Text
| Distinct | 142 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 12 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 100-CI-T01 |
|---|---|
| 2nd row | 108-VN-T01 |
| 3rd row | 100-CI-T01 |
| 4th row | 108-VN-T01 |
| 5th row | 108-VN-T01 |
| Value | Count | Frequency (%) |
| 116-za-t30 | 768 | 7.4% |
| 104-ci-t30 | 729 | 7.1% |
| 151-ng-t30 | 628 | 6.1% |
| 114-ug-t30 | 596 | 5.8% |
| 108-vn-t30 | 522 | 5.1% |
| 106-ht-t30 | 450 | 4.4% |
| 111-mz-t30 | 431 | 4.2% |
| 110-zm-t30 | 406 | 3.9% |
| 109-tz-t30 | 369 | 3.6% |
| 107-rw-t30 | 340 | 3.3% |
| Other values (132) | 5085 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 20648 | |
| 1 | 18694 | |
| 0 | 16409 | |
| T | 11732 | |
| 3 | 8596 | |
| Z | 3815 | 3.7% |
| G | 2289 | 2.2% |
| 6 | 2032 | 2.0% |
| N | 1981 | 1.9% |
| 4 | 1852 | 1.8% |
| Other values (25) | 15192 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 103240 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 20648 | |
| 1 | 18694 | |
| 0 | 16409 | |
| T | 11732 | |
| 3 | 8596 | |
| Z | 3815 | 3.7% |
| G | 2289 | 2.2% |
| 6 | 2032 | 2.0% |
| N | 1981 | 1.9% |
| 4 | 1852 | 1.8% |
| Other values (25) | 15192 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 103240 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 20648 | |
| 1 | 18694 | |
| 0 | 16409 | |
| T | 11732 | |
| 3 | 8596 | |
| Z | 3815 | 3.7% |
| G | 2289 | 2.2% |
| 6 | 2032 | 2.0% |
| N | 1981 | 1.9% |
| 4 | 1852 | 1.8% |
| Other values (25) | 15192 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 103240 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 20648 | |
| 1 | 18694 | |
| 0 | 16409 | |
| T | 11732 | |
| 3 | 8596 | |
| Z | 3815 | 3.7% |
| G | 2289 | 2.2% |
| 6 | 2032 | 2.0% |
| N | 1981 | 1.9% |
| 4 | 1852 | 1.8% |
| Other values (25) | 15192 |
pq #
Text
| Distinct | 1237 |
|---|---|
| Distinct (%) | 12.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
Length
| Max length | 14 |
|---|---|
| Median length | 9 |
| Mean length | 9.9468229 |
| Min length | 8 |
Unique
| Unique | 380 ? |
|---|---|
| Unique (%) | 3.7% |
Sample
| 1st row | Pre-PQ Process |
|---|---|
| 2nd row | Pre-PQ Process |
| 3rd row | Pre-PQ Process |
| 4th row | Pre-PQ Process |
| 5th row | Pre-PQ Process |
| Value | Count | Frequency (%) |
| pre-pq | 2681 | 20.6% |
| process | 2681 | 20.6% |
| fpq-14942 | 205 | 1.6% |
| fpq-12522 | 154 | 1.2% |
| fpq-13973 | 110 | 0.8% |
| fpq-4537 | 98 | 0.8% |
| fpq-8840 | 90 | 0.7% |
| fpq-7175 | 78 | 0.6% |
| fpq-5303 | 78 | 0.6% |
| fpq-6262 | 75 | 0.6% |
| Other values (1228) | 6755 |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 15686 | |
| Q | 10324 | 10.1% |
| - | 10324 | 10.1% |
| F | 7643 | 7.4% |
| 1 | 6503 | 6.3% |
| s | 5362 | 5.2% |
| e | 5362 | 5.2% |
| r | 5362 | 5.2% |
| 2 | 3851 | 3.8% |
| 4 | 3824 | 3.7% |
| Other values (10) | 28450 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 102691 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| P | 15686 | |
| Q | 10324 | 10.1% |
| - | 10324 | 10.1% |
| F | 7643 | 7.4% |
| 1 | 6503 | 6.3% |
| s | 5362 | 5.2% |
| e | 5362 | 5.2% |
| r | 5362 | 5.2% |
| 2 | 3851 | 3.8% |
| 4 | 3824 | 3.7% |
| Other values (10) | 28450 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 102691 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| P | 15686 | |
| Q | 10324 | 10.1% |
| - | 10324 | 10.1% |
| F | 7643 | 7.4% |
| 1 | 6503 | 6.3% |
| s | 5362 | 5.2% |
| e | 5362 | 5.2% |
| r | 5362 | 5.2% |
| 2 | 3851 | 3.8% |
| 4 | 3824 | 3.7% |
| Other values (10) | 28450 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 102691 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| P | 15686 | |
| Q | 10324 | 10.1% |
| - | 10324 | 10.1% |
| F | 7643 | 7.4% |
| 1 | 6503 | 6.3% |
| s | 5362 | 5.2% |
| e | 5362 | 5.2% |
| r | 5362 | 5.2% |
| 2 | 3851 | 3.8% |
| 4 | 3824 | 3.7% |
| Other values (10) | 28450 |
po / so #
Text
| Distinct | 6233 |
|---|---|
| Distinct (%) | 60.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 9.0565672 |
| Min length | 6 |
Unique
| Unique | 4540 ? |
|---|---|
| Unique (%) | 44.0% |
Sample
| 1st row | SCMS-4 |
|---|---|
| 2nd row | SCMS-13 |
| 3rd row | SCMS-20 |
| 4th row | SCMS-78 |
| 5th row | SCMS-81 |
| Value | Count | Frequency (%) |
| scms-199289 | 67 | 0.6% |
| scms-199283 | 63 | 0.6% |
| scms-183950 | 55 | 0.5% |
| scms-259075 | 38 | 0.4% |
| scms-215370 | 38 | 0.4% |
| scms-259079 | 33 | 0.3% |
| scms-23500 | 26 | 0.3% |
| scms-215410 | 26 | 0.3% |
| scms-259078 | 20 | 0.2% |
| scms-162440 | 20 | 0.2% |
| Other values (6223) | 9938 |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 15243 | |
| - | 10324 | |
| 0 | 10280 | |
| 1 | 6433 | 6.9% |
| 4 | 6052 | 6.5% |
| 2 | 5714 | 6.1% |
| 3 | 5482 | 5.9% |
| O | 5404 | 5.8% |
| C | 4920 | 5.3% |
| M | 4920 | 5.3% |
| Other values (6) | 18728 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 93500 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| S | 15243 | |
| - | 10324 | |
| 0 | 10280 | |
| 1 | 6433 | 6.9% |
| 4 | 6052 | 6.5% |
| 2 | 5714 | 6.1% |
| 3 | 5482 | 5.9% |
| O | 5404 | 5.8% |
| C | 4920 | 5.3% |
| M | 4920 | 5.3% |
| Other values (6) | 18728 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 93500 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| S | 15243 | |
| - | 10324 | |
| 0 | 10280 | |
| 1 | 6433 | 6.9% |
| 4 | 6052 | 6.5% |
| 2 | 5714 | 6.1% |
| 3 | 5482 | 5.9% |
| O | 5404 | 5.8% |
| C | 4920 | 5.3% |
| M | 4920 | 5.3% |
| Other values (6) | 18728 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 93500 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| S | 15243 | |
| - | 10324 | |
| 0 | 10280 | |
| 1 | 6433 | 6.9% |
| 4 | 6052 | 6.5% |
| 2 | 5714 | 6.1% |
| 3 | 5482 | 5.9% |
| O | 5404 | 5.8% |
| C | 4920 | 5.3% |
| M | 4920 | 5.3% |
| Other values (6) | 18728 |
asn/dn #
Text
| Distinct | 7030 |
|---|---|
| Distinct (%) | 68.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 7.6271794 |
| Min length | 4 |
Unique
| Unique | 5580 ? |
|---|---|
| Unique (%) | 54.0% |
Sample
| 1st row | ASN-8 |
|---|---|
| 2nd row | ASN-85 |
| 3rd row | ASN-14 |
| 4th row | ASN-50 |
| 5th row | ASN-55 |
| Value | Count | Frequency (%) |
| asn-19166 | 54 | 0.5% |
| asn-24415 | 38 | 0.4% |
| asn-23875 | 26 | 0.3% |
| asn-32138 | 19 | 0.2% |
| asn-28036 | 17 | 0.2% |
| asn-28034 | 17 | 0.2% |
| dn-304 | 17 | 0.2% |
| asn-28033 | 17 | 0.2% |
| asn-30792 | 17 | 0.2% |
| asn-1520 | 16 | 0.2% |
| Other values (7020) | 10086 |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 10324 | |
| - | 10324 | |
| 2 | 6558 | 8.3% |
| 1 | 6137 | 7.8% |
| 3 | 5629 | 7.1% |
| D | 5404 | 6.9% |
| A | 4920 | 6.2% |
| S | 4920 | 6.2% |
| 4 | 3911 | 5.0% |
| 7 | 3586 | 4.6% |
| Other values (5) | 17030 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 78743 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| N | 10324 | |
| - | 10324 | |
| 2 | 6558 | 8.3% |
| 1 | 6137 | 7.8% |
| 3 | 5629 | 7.1% |
| D | 5404 | 6.9% |
| A | 4920 | 6.2% |
| S | 4920 | 6.2% |
| 4 | 3911 | 5.0% |
| 7 | 3586 | 4.6% |
| Other values (5) | 17030 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 78743 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| N | 10324 | |
| - | 10324 | |
| 2 | 6558 | 8.3% |
| 1 | 6137 | 7.8% |
| 3 | 5629 | 7.1% |
| D | 5404 | 6.9% |
| A | 4920 | 6.2% |
| S | 4920 | 6.2% |
| 4 | 3911 | 5.0% |
| 7 | 3586 | 4.6% |
| Other values (5) | 17030 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 78743 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| N | 10324 | |
| - | 10324 | |
| 2 | 6558 | 8.3% |
| 1 | 6137 | 7.8% |
| 3 | 5629 | 7.1% |
| D | 5404 | 6.9% |
| A | 4920 | 6.2% |
| S | 4920 | 6.2% |
| 4 | 3911 | 5.0% |
| 7 | 3586 | 4.6% |
| Other values (5) | 17030 |
country
Categorical
High correlation 
| Distinct | 43 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
| South Africa | |
|---|---|
| Nigeria | |
| Côte d'Ivoire | |
| Uganda | |
| Vietnam | |
| Other values (38) |
Length
| Max length | 18 |
|---|---|
| Median length | 12 |
| Mean length | 8.4762689 |
| Min length | 4 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Côte d'Ivoire |
|---|---|
| 2nd row | Vietnam |
| 3rd row | Côte d'Ivoire |
| 4th row | Vietnam |
| 5th row | Vietnam |
Common Values
| Value | Count | Frequency (%) |
| South Africa | 1406 | |
| Nigeria | 1194 | |
| Côte d'Ivoire | 1083 | |
| Uganda | 779 | 7.5% |
| Vietnam | 688 | 6.7% |
| Zambia | 683 | 6.6% |
| Haiti | 655 | 6.3% |
| Mozambique | 631 | 6.1% |
| Zimbabwe | 538 | 5.2% |
| Tanzania | 519 | 5.0% |
| Other values (33) | 2148 |
Length
| Value | Count | Frequency (%) |
| south | 1570 | |
| africa | 1406 | 10.5% |
| nigeria | 1194 | 8.9% |
| côte | 1083 | 8.1% |
| d'ivoire | 1083 | 8.1% |
| uganda | 779 | 5.8% |
| vietnam | 688 | 5.1% |
| zambia | 683 | 5.1% |
| haiti | 655 | 4.9% |
| mozambique | 631 | 4.7% |
| Other values (38) | 3596 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 12282 | 14.0% |
| i | 10247 | 11.7% |
| e | 5522 | 6.3% |
| o | 4473 | 5.1% |
| n | 4350 | 5.0% |
| t | 4323 | 4.9% |
| r | 3874 | 4.4% |
| 3044 | 3.5% | |
| u | 2914 | 3.3% |
| m | 2777 | 3.2% |
| Other values (38) | 33703 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 87509 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 12282 | 14.0% |
| i | 10247 | 11.7% |
| e | 5522 | 6.3% |
| o | 4473 | 5.1% |
| n | 4350 | 5.0% |
| t | 4323 | 4.9% |
| r | 3874 | 4.4% |
| 3044 | 3.5% | |
| u | 2914 | 3.3% |
| m | 2777 | 3.2% |
| Other values (38) | 33703 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 87509 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 12282 | 14.0% |
| i | 10247 | 11.7% |
| e | 5522 | 6.3% |
| o | 4473 | 5.1% |
| n | 4350 | 5.0% |
| t | 4323 | 4.9% |
| r | 3874 | 4.4% |
| 3044 | 3.5% | |
| u | 2914 | 3.3% |
| m | 2777 | 3.2% |
| Other values (38) | 33703 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 87509 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 12282 | 14.0% |
| i | 10247 | 11.7% |
| e | 5522 | 6.3% |
| o | 4473 | 5.1% |
| n | 4350 | 5.0% |
| t | 4323 | 4.9% |
| r | 3874 | 4.4% |
| 3044 | 3.5% | |
| u | 2914 | 3.3% |
| m | 2777 | 3.2% |
| Other values (38) | 33703 |
managed by
Categorical
Imbalance 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
| PMO - US | |
|---|---|
| South Africa Field Office | 57 |
| Haiti Field Office | 1 |
| Ethiopia Field Office | 1 |
Length
| Max length | 25 |
|---|---|
| Median length | 8 |
| Mean length | 8.0960868 |
| Min length | 8 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | PMO - US |
|---|---|
| 2nd row | PMO - US |
| 3rd row | PMO - US |
| 4th row | PMO - US |
| 5th row | PMO - US |
Common Values
| Value | Count | Frequency (%) |
| PMO - US | 10265 | |
| South Africa Field Office | 57 | 0.6% |
| Haiti Field Office | 1 | < 0.1% |
| Ethiopia Field Office | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| pmo | 10265 | |
| 10265 | ||
| us | 10265 | |
| field | 59 | 0.2% |
| office | 59 | 0.2% |
| south | 57 | 0.2% |
| africa | 57 | 0.2% |
| haiti | 1 | < 0.1% |
| ethiopia | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 20705 | ||
| O | 10324 | |
| S | 10322 | |
| P | 10265 | |
| M | 10265 | |
| - | 10265 | |
| U | 10265 | |
| i | 179 | 0.2% |
| f | 175 | 0.2% |
| e | 118 | 0.1% |
| Other values (14) | 701 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 83584 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 20705 | ||
| O | 10324 | |
| S | 10322 | |
| P | 10265 | |
| M | 10265 | |
| - | 10265 | |
| U | 10265 | |
| i | 179 | 0.2% |
| f | 175 | 0.2% |
| e | 118 | 0.1% |
| Other values (14) | 701 | 0.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 83584 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 20705 | ||
| O | 10324 | |
| S | 10322 | |
| P | 10265 | |
| M | 10265 | |
| - | 10265 | |
| U | 10265 | |
| i | 179 | 0.2% |
| f | 175 | 0.2% |
| e | 118 | 0.1% |
| Other values (14) | 701 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 83584 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 20705 | ||
| O | 10324 | |
| S | 10322 | |
| P | 10265 | |
| M | 10265 | |
| - | 10265 | |
| U | 10265 | |
| i | 179 | 0.2% |
| f | 175 | 0.2% |
| e | 118 | 0.1% |
| Other values (14) | 701 | 0.8% |
fulfill via
Categorical
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
| From RDC | |
|---|---|
| Direct Drop |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 9.4296784 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Direct Drop |
|---|---|
| 2nd row | Direct Drop |
| 3rd row | Direct Drop |
| 4th row | Direct Drop |
| 5th row | Direct Drop |
Common Values
| Value | Count | Frequency (%) |
| From RDC | 5404 | |
| Direct Drop | 4920 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| from | 5404 | |
| rdc | 5404 | |
| direct | 4920 | |
| drop | 4920 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 15244 | |
| D | 15244 | |
| o | 10324 | |
| 10324 | ||
| F | 5404 | 5.6% |
| m | 5404 | 5.6% |
| R | 5404 | 5.6% |
| C | 5404 | 5.6% |
| i | 4920 | 5.1% |
| e | 4920 | 5.1% |
| Other values (3) | 14760 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 97352 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 15244 | |
| D | 15244 | |
| o | 10324 | |
| 10324 | ||
| F | 5404 | 5.6% |
| m | 5404 | 5.6% |
| R | 5404 | 5.6% |
| C | 5404 | 5.6% |
| i | 4920 | 5.1% |
| e | 4920 | 5.1% |
| Other values (3) | 14760 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 97352 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 15244 | |
| D | 15244 | |
| o | 10324 | |
| 10324 | ||
| F | 5404 | 5.6% |
| m | 5404 | 5.6% |
| R | 5404 | 5.6% |
| C | 5404 | 5.6% |
| i | 4920 | 5.1% |
| e | 4920 | 5.1% |
| Other values (3) | 14760 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 97352 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 15244 | |
| D | 15244 | |
| o | 10324 | |
| 10324 | ||
| F | 5404 | 5.6% |
| m | 5404 | 5.6% |
| R | 5404 | 5.6% |
| C | 5404 | 5.6% |
| i | 4920 | 5.1% |
| e | 4920 | 5.1% |
| Other values (3) | 14760 |
vendor inco term
Categorical
High correlation 
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
| N/A - From RDC | |
|---|---|
| EXW | |
| DDP | |
| FCA | 397 |
| CIP | 275 |
| Other values (3) | 27 |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 8.7578458 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | EXW |
|---|---|
| 2nd row | EXW |
| 3rd row | FCA |
| 4th row | EXW |
| 5th row | EXW |
Common Values
| Value | Count | Frequency (%) |
| N/A - From RDC | 5404 | |
| EXW | 2778 | |
| DDP | 1443 | 14.0% |
| FCA | 397 | 3.8% |
| CIP | 275 | 2.7% |
| DDU | 15 | 0.1% |
| DAP | 9 | 0.1% |
| CIF | 3 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| n/a | 5404 | |
| 5404 | ||
| from | 5404 | |
| rdc | 5404 | |
| exw | 2778 | |
| ddp | 1443 | 5.4% |
| fca | 397 | 1.5% |
| cip | 275 | 1.0% |
| ddu | 15 | 0.1% |
| dap | 9 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 16212 | ||
| D | 8329 | 9.2% |
| C | 6079 | 6.7% |
| A | 5810 | 6.4% |
| F | 5804 | 6.4% |
| N | 5404 | 6.0% |
| m | 5404 | 6.0% |
| / | 5404 | 6.0% |
| R | 5404 | 6.0% |
| o | 5404 | 6.0% |
| Other values (8) | 21162 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 90416 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 16212 | ||
| D | 8329 | 9.2% |
| C | 6079 | 6.7% |
| A | 5810 | 6.4% |
| F | 5804 | 6.4% |
| N | 5404 | 6.0% |
| m | 5404 | 6.0% |
| / | 5404 | 6.0% |
| R | 5404 | 6.0% |
| o | 5404 | 6.0% |
| Other values (8) | 21162 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 90416 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 16212 | ||
| D | 8329 | 9.2% |
| C | 6079 | 6.7% |
| A | 5810 | 6.4% |
| F | 5804 | 6.4% |
| N | 5404 | 6.0% |
| m | 5404 | 6.0% |
| / | 5404 | 6.0% |
| R | 5404 | 6.0% |
| o | 5404 | 6.0% |
| Other values (8) | 21162 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 90416 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 16212 | ||
| D | 8329 | 9.2% |
| C | 6079 | 6.7% |
| A | 5810 | 6.4% |
| F | 5804 | 6.4% |
| N | 5404 | 6.0% |
| m | 5404 | 6.0% |
| / | 5404 | 6.0% |
| R | 5404 | 6.0% |
| o | 5404 | 6.0% |
| Other values (8) | 21162 |
shipment mode
Categorical
High correlation  Missing 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 360 |
| Missing (%) | 3.5% |
| Memory size | 80.8 KiB |
| Air | |
|---|---|
| Truck | |
| Air Charter | |
| Ocean | 371 |
Length
| Max length | 11 |
|---|---|
| Median length | 3 |
| Mean length | 4.1643918 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Air |
|---|---|
| 2nd row | Air |
| 3rd row | Air |
| 4th row | Air |
| 5th row | Air |
Common Values
| Value | Count | Frequency (%) |
| Air | 6113 | |
| Truck | 2830 | |
| Air Charter | 650 | 6.3% |
| Ocean | 371 | 3.6% |
| (Missing) | 360 | 3.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| air | 6763 | |
| truck | 2830 | |
| charter | 650 | 6.1% |
| ocean | 371 | 3.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 10893 | |
| A | 6763 | |
| i | 6763 | |
| c | 3201 | 7.7% |
| T | 2830 | 6.8% |
| u | 2830 | 6.8% |
| k | 2830 | 6.8% |
| a | 1021 | 2.5% |
| e | 1021 | 2.5% |
| 650 | 1.6% | |
| Other values (5) | 2692 | 6.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 41494 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 10893 | |
| A | 6763 | |
| i | 6763 | |
| c | 3201 | 7.7% |
| T | 2830 | 6.8% |
| u | 2830 | 6.8% |
| k | 2830 | 6.8% |
| a | 1021 | 2.5% |
| e | 1021 | 2.5% |
| 650 | 1.6% | |
| Other values (5) | 2692 | 6.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 41494 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 10893 | |
| A | 6763 | |
| i | 6763 | |
| c | 3201 | 7.7% |
| T | 2830 | 6.8% |
| u | 2830 | 6.8% |
| k | 2830 | 6.8% |
| a | 1021 | 2.5% |
| e | 1021 | 2.5% |
| 650 | 1.6% | |
| Other values (5) | 2692 | 6.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 41494 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 10893 | |
| A | 6763 | |
| i | 6763 | |
| c | 3201 | 7.7% |
| T | 2830 | 6.8% |
| u | 2830 | 6.8% |
| k | 2830 | 6.8% |
| a | 1021 | 2.5% |
| e | 1021 | 2.5% |
| 650 | 1.6% | |
| Other values (5) | 2692 | 6.5% |
| Distinct | 765 |
|---|---|
| Distinct (%) | 7.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
Length
| Max length | 17 |
|---|---|
| Median length | 14 |
| Mean length | 10.355579 |
| Min length | 8 |
Unique
| Unique | 133 ? |
|---|---|
| Unique (%) | 1.3% |
Sample
| 1st row | Pre-PQ Process |
|---|---|
| 2nd row | Pre-PQ Process |
| 3rd row | Pre-PQ Process |
| 4th row | Pre-PQ Process |
| 5th row | Pre-PQ Process |
| Value | Count | Frequency (%) |
| pre-pq | 2476 | 18.7% |
| process | 2476 | 18.7% |
| 9/11/2014 | 205 | 1.6% |
| date | 205 | 1.6% |
| not | 205 | 1.6% |
| captured | 205 | 1.6% |
| 7/11/2013 | 173 | 1.3% |
| 4/30/2014 | 123 | 0.9% |
| 11/6/2009 | 98 | 0.7% |
| 11/21/2011 | 90 | 0.7% |
| Other values (758) | 6954 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 15328 | |
| / | 15286 | |
| 2 | 12611 | |
| 0 | 11326 | |
| P | 7428 | 6.9% |
| e | 5362 | 5.0% |
| r | 5157 | 4.8% |
| s | 4952 | 4.6% |
| 3 | 3479 | 3.3% |
| 4 | 2986 | 2.8% |
| Other values (18) | 22996 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 106911 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 15328 | |
| / | 15286 | |
| 2 | 12611 | |
| 0 | 11326 | |
| P | 7428 | 6.9% |
| e | 5362 | 5.0% |
| r | 5157 | 4.8% |
| s | 4952 | 4.6% |
| 3 | 3479 | 3.3% |
| 4 | 2986 | 2.8% |
| Other values (18) | 22996 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 106911 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 15328 | |
| / | 15286 | |
| 2 | 12611 | |
| 0 | 11326 | |
| P | 7428 | 6.9% |
| e | 5362 | 5.0% |
| r | 5157 | 4.8% |
| s | 4952 | 4.6% |
| 3 | 3479 | 3.3% |
| 4 | 2986 | 2.8% |
| Other values (18) | 22996 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 106911 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 15328 | |
| / | 15286 | |
| 2 | 12611 | |
| 0 | 11326 | |
| P | 7428 | 6.9% |
| e | 5362 | 5.0% |
| r | 5157 | 4.8% |
| s | 4952 | 4.6% |
| 3 | 3479 | 3.3% |
| 4 | 2986 | 2.8% |
| Other values (18) | 22996 |
| Distinct | 897 |
|---|---|
| Distinct (%) | 8.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
Length
| Max length | 17 |
|---|---|
| Median length | 14 |
| Mean length | 11.849961 |
| Min length | 8 |
Unique
| Unique | 256 ? |
|---|---|
| Unique (%) | 2.5% |
Sample
| 1st row | Date Not Captured |
|---|---|
| 2nd row | Date Not Captured |
| 3rd row | Date Not Captured |
| 4th row | Date Not Captured |
| 5th row | Date Not Captured |
| Value | Count | Frequency (%) |
| n/a | 5404 | |
| 5404 | ||
| from | 5404 | |
| rdc | 5404 | |
| date | 328 | 1.2% |
| not | 328 | 1.2% |
| captured | 328 | 1.2% |
| 8/27/2014 | 80 | 0.3% |
| 3/19/2010 | 78 | 0.3% |
| 8/29/2014 | 76 | 0.3% |
| Other values (892) | 4358 |
Most occurring characters
| Value | Count | Frequency (%) |
| 16868 | ||
| / | 14588 | 11.9% |
| 2 | 7921 | 6.5% |
| 1 | 7602 | 6.2% |
| 0 | 7063 | 5.8% |
| o | 5732 | 4.7% |
| D | 5732 | 4.7% |
| N | 5732 | 4.7% |
| r | 5732 | 4.7% |
| C | 5732 | 4.7% |
| Other values (18) | 39637 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 122339 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 16868 | ||
| / | 14588 | 11.9% |
| 2 | 7921 | 6.5% |
| 1 | 7602 | 6.2% |
| 0 | 7063 | 5.8% |
| o | 5732 | 4.7% |
| D | 5732 | 4.7% |
| N | 5732 | 4.7% |
| r | 5732 | 4.7% |
| C | 5732 | 4.7% |
| Other values (18) | 39637 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 122339 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 16868 | ||
| / | 14588 | 11.9% |
| 2 | 7921 | 6.5% |
| 1 | 7602 | 6.2% |
| 0 | 7063 | 5.8% |
| o | 5732 | 4.7% |
| D | 5732 | 4.7% |
| N | 5732 | 4.7% |
| r | 5732 | 4.7% |
| C | 5732 | 4.7% |
| Other values (18) | 39637 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 122339 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 16868 | ||
| / | 14588 | 11.9% |
| 2 | 7921 | 6.5% |
| 1 | 7602 | 6.2% |
| 0 | 7063 | 5.8% |
| o | 5732 | 4.7% |
| D | 5732 | 4.7% |
| N | 5732 | 4.7% |
| r | 5732 | 4.7% |
| C | 5732 | 4.7% |
| Other values (18) | 39637 |
| Distinct | 2006 |
|---|---|
| Distinct (%) | 19.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
| Minimum | 2006-05-02 00:00:00 |
|---|---|
| Maximum | 2015-12-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
| Distinct | 2093 |
|---|---|
| Distinct (%) | 20.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
| Minimum | 2006-05-02 00:00:00 |
|---|---|
| Maximum | 2015-09-14 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
| Distinct | 2042 |
|---|---|
| Distinct (%) | 19.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
| Minimum | 2006-05-02 00:00:00 |
|---|---|
| Maximum | 2015-09-14 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
product group
Categorical
High correlation  Imbalance 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
| ARV | |
|---|---|
| HRDT | |
| ANTM | 22 |
| ACT | 16 |
| MRDT | 8 |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.1702828 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | HRDT |
|---|---|
| 2nd row | ARV |
| 3rd row | HRDT |
| 4th row | ARV |
| 5th row | ARV |
Common Values
| Value | Count | Frequency (%) |
| ARV | 8550 | |
| HRDT | 1728 | 16.7% |
| ANTM | 22 | 0.2% |
| ACT | 16 | 0.2% |
| MRDT | 8 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| arv | 8550 | |
| hrdt | 1728 | 16.7% |
| antm | 22 | 0.2% |
| act | 16 | 0.2% |
| mrdt | 8 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 10286 | |
| A | 8588 | |
| V | 8550 | |
| T | 1774 | 5.4% |
| D | 1736 | 5.3% |
| H | 1728 | 5.3% |
| M | 30 | 0.1% |
| N | 22 | 0.1% |
| C | 16 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 32730 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| R | 10286 | |
| A | 8588 | |
| V | 8550 | |
| T | 1774 | 5.4% |
| D | 1736 | 5.3% |
| H | 1728 | 5.3% |
| M | 30 | 0.1% |
| N | 22 | 0.1% |
| C | 16 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 32730 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| R | 10286 | |
| A | 8588 | |
| V | 8550 | |
| T | 1774 | 5.4% |
| D | 1736 | 5.3% |
| H | 1728 | 5.3% |
| M | 30 | 0.1% |
| N | 22 | 0.1% |
| C | 16 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 32730 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| R | 10286 | |
| A | 8588 | |
| V | 8550 | |
| T | 1774 | 5.4% |
| D | 1736 | 5.3% |
| H | 1728 | 5.3% |
| M | 30 | 0.1% |
| N | 22 | 0.1% |
| C | 16 | < 0.1% |
sub classification
Categorical
High correlation 
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
| Adult | |
|---|---|
| Pediatric | |
| HIV test | |
| HIV test - Ancillary | 161 |
| Malaria | 30 |
Length
| Max length | 20 |
|---|---|
| Median length | 5 |
| Mean length | 6.4494382 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | HIV test |
|---|---|
| 2nd row | Pediatric |
| 3rd row | HIV test |
| 4th row | Adult |
| 5th row | Adult |
Common Values
| Value | Count | Frequency (%) |
| Adult | 6595 | |
| Pediatric | 1955 | 18.9% |
| HIV test | 1567 | 15.2% |
| HIV test - Ancillary | 161 | 1.6% |
| Malaria | 30 | 0.3% |
| ACT | 16 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| adult | 6595 | |
| pediatric | 1955 | 15.8% |
| hiv | 1728 | 14.0% |
| test | 1728 | 14.0% |
| 161 | 1.3% | |
| ancillary | 161 | 1.3% |
| malaria | 30 | 0.2% |
| act | 16 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 12006 | |
| d | 8550 | |
| l | 6947 | |
| A | 6772 | |
| u | 6595 | |
| i | 4101 | 6.2% |
| e | 3683 | 5.5% |
| a | 2206 | 3.3% |
| r | 2146 | 3.2% |
| c | 2116 | 3.2% |
| Other values (12) | 11462 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 66584 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 12006 | |
| d | 8550 | |
| l | 6947 | |
| A | 6772 | |
| u | 6595 | |
| i | 4101 | 6.2% |
| e | 3683 | 5.5% |
| a | 2206 | 3.3% |
| r | 2146 | 3.2% |
| c | 2116 | 3.2% |
| Other values (12) | 11462 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 66584 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 12006 | |
| d | 8550 | |
| l | 6947 | |
| A | 6772 | |
| u | 6595 | |
| i | 4101 | 6.2% |
| e | 3683 | 5.5% |
| a | 2206 | 3.3% |
| r | 2146 | 3.2% |
| c | 2116 | 3.2% |
| Other values (12) | 11462 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 66584 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 12006 | |
| d | 8550 | |
| l | 6947 | |
| A | 6772 | |
| u | 6595 | |
| i | 4101 | 6.2% |
| e | 3683 | 5.5% |
| a | 2206 | 3.3% |
| r | 2146 | 3.2% |
| c | 2116 | 3.2% |
| Other values (12) | 11462 |
vendor
Text
| Distinct | 73 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
Length
| Max length | 65 |
|---|---|
| Median length | 13 |
| Mean length | 18.53332 |
| Min length | 7 |
Unique
| Unique | 19 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | RANBAXY Fine Chemicals LTD. |
|---|---|
| 2nd row | Aurobindo Pharma Limited |
| 3rd row | Abbott GmbH & Co. KG |
| 4th row | SUN PHARMACEUTICAL INDUSTRIES LTD (RANBAXY LABORATORIES LIMITED) |
| 5th row | Aurobindo Pharma Limited |
| Value | Count | Frequency (%) |
| scms | 5404 | |
| rdc | 5404 | |
| from | 5404 | |
| limited | 1288 | 3.9% |
| ltd | 1169 | 3.6% |
| orgenics | 754 | 2.3% |
| s | 717 | 2.2% |
| buys | 715 | 2.2% |
| wholesaler | 715 | 2.2% |
| laboratories | 705 | 2.2% |
| Other values (158) | 10470 |
Most occurring characters
| Value | Count | Frequency (%) |
| 22491 | 11.8% | |
| S | 16965 | 8.9% |
| C | 13420 | 7.0% |
| R | 11481 | 6.0% |
| M | 8653 | 4.5% |
| r | 8112 | 4.2% |
| D | 7485 | 3.9% |
| o | 7434 | 3.9% |
| L | 7380 | 3.9% |
| m | 6798 | 3.6% |
| Other values (44) | 81119 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 191338 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 22491 | 11.8% | |
| S | 16965 | 8.9% |
| C | 13420 | 7.0% |
| R | 11481 | 6.0% |
| M | 8653 | 4.5% |
| r | 8112 | 4.2% |
| D | 7485 | 3.9% |
| o | 7434 | 3.9% |
| L | 7380 | 3.9% |
| m | 6798 | 3.6% |
| Other values (44) | 81119 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 191338 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 22491 | 11.8% | |
| S | 16965 | 8.9% |
| C | 13420 | 7.0% |
| R | 11481 | 6.0% |
| M | 8653 | 4.5% |
| r | 8112 | 4.2% |
| D | 7485 | 3.9% |
| o | 7434 | 3.9% |
| L | 7380 | 3.9% |
| m | 6798 | 3.6% |
| Other values (44) | 81119 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 191338 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 22491 | 11.8% | |
| S | 16965 | 8.9% |
| C | 13420 | 7.0% |
| R | 11481 | 6.0% |
| M | 8653 | 4.5% |
| r | 8112 | 4.2% |
| D | 7485 | 3.9% |
| o | 7434 | 3.9% |
| L | 7380 | 3.9% |
| m | 6798 | 3.6% |
| Other values (44) | 81119 |
item description
Text
| Distinct | 184 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
Length
| Max length | 113 |
|---|---|
| Median length | 79 |
| Mean length | 50.144808 |
| Min length | 31 |
Unique
| Unique | 23 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | HIV, Reveal G3 Rapid HIV-1 Antibody Test, 30 Tests |
|---|---|
| 2nd row | Nevirapine 10mg/ml, oral suspension, Bottle, 240 ml |
| 3rd row | HIV 1/2, Determine Complete HIV Kit, 100 Tests |
| 4th row | Lamivudine 150mg, tablets, 60 Tabs |
| 5th row | Stavudine 30mg, capsules, 60 Caps |
| Value | Count | Frequency (%) |
| tablets | 6733 | 10.3% |
| tabs | 6711 | 10.2% |
| 60 | 4269 | 6.5% |
| hiv | 3006 | 4.6% |
| 30 | 2598 | 4.0% |
| tests | 1616 | 2.5% |
| kit | 1579 | 2.4% |
| 1/2 | 1524 | 2.3% |
| disoproxil | 1300 | 2.0% |
| fumarate | 1300 | 2.0% |
| Other values (289) | 34956 |
Most occurring characters
| Value | Count | Frequency (%) |
| 55268 | 10.7% | |
| i | 33699 | 6.5% |
| a | 33528 | 6.5% |
| 0 | 33249 | 6.4% |
| e | 33073 | 6.4% |
| t | 26685 | 5.2% |
| s | 24970 | 4.8% |
| , | 22576 | 4.4% |
| l | 17483 | 3.4% |
| n | 17399 | 3.4% |
| Other values (63) | 219765 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 517695 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 55268 | 10.7% | |
| i | 33699 | 6.5% |
| a | 33528 | 6.5% |
| 0 | 33249 | 6.4% |
| e | 33073 | 6.4% |
| t | 26685 | 5.2% |
| s | 24970 | 4.8% |
| , | 22576 | 4.4% |
| l | 17483 | 3.4% |
| n | 17399 | 3.4% |
| Other values (63) | 219765 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 517695 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 55268 | 10.7% | |
| i | 33699 | 6.5% |
| a | 33528 | 6.5% |
| 0 | 33249 | 6.4% |
| e | 33073 | 6.4% |
| t | 26685 | 5.2% |
| s | 24970 | 4.8% |
| , | 22576 | 4.4% |
| l | 17483 | 3.4% |
| n | 17399 | 3.4% |
| Other values (63) | 219765 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 517695 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 55268 | 10.7% | |
| i | 33699 | 6.5% |
| a | 33528 | 6.5% |
| 0 | 33249 | 6.4% |
| e | 33073 | 6.4% |
| t | 26685 | 5.2% |
| s | 24970 | 4.8% |
| , | 22576 | 4.4% |
| l | 17483 | 3.4% |
| n | 17399 | 3.4% |
| Other values (63) | 219765 |
| Distinct | 86 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
Length
| Max length | 98 |
|---|---|
| Median length | 60 |
| Mean length | 22.15091 |
| Min length | 7 |
Unique
| Unique | 14 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | HIV, Reveal G3 Rapid HIV-1 Antibody Test |
|---|---|
| 2nd row | Nevirapine |
| 3rd row | HIV 1/2, Determine Complete HIV Kit |
| 4th row | Lamivudine |
| 5th row | Stavudine |
| Value | Count | Frequency (%) |
| hiv | 3055 | 13.6% |
| kit | 1579 | 7.0% |
| 1/2 | 1524 | 6.8% |
| disoproxil | 1300 | 5.8% |
| fumarate | 1300 | 5.8% |
| efavirenz | 1125 | 5.0% |
| nevirapine | 877 | 3.9% |
| determine | 799 | 3.6% |
| lamivudine/nevirapine/zidovudine | 707 | 3.2% |
| lamivudine/zidovudine | 689 | 3.1% |
| Other values (148) | 9451 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 30297 | 13.2% |
| e | 19499 | 8.5% |
| a | 15535 | 6.8% |
| n | 15469 | 6.8% |
| v | 13084 | 5.7% |
| 12082 | 5.3% | |
| r | 11537 | 5.0% |
| o | 10997 | 4.8% |
| d | 9170 | 4.0% |
| t | 8291 | 3.6% |
| Other values (53) | 82725 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 228686 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 30297 | 13.2% |
| e | 19499 | 8.5% |
| a | 15535 | 6.8% |
| n | 15469 | 6.8% |
| v | 13084 | 5.7% |
| 12082 | 5.3% | |
| r | 11537 | 5.0% |
| o | 10997 | 4.8% |
| d | 9170 | 4.0% |
| t | 8291 | 3.6% |
| Other values (53) | 82725 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 228686 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 30297 | 13.2% |
| e | 19499 | 8.5% |
| a | 15535 | 6.8% |
| n | 15469 | 6.8% |
| v | 13084 | 5.7% |
| 12082 | 5.3% | |
| r | 11537 | 5.0% |
| o | 10997 | 4.8% |
| d | 9170 | 4.0% |
| t | 8291 | 3.6% |
| Other values (53) | 82725 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 228686 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 30297 | 13.2% |
| e | 19499 | 8.5% |
| a | 15535 | 6.8% |
| n | 15469 | 6.8% |
| v | 13084 | 5.7% |
| 12082 | 5.3% | |
| r | 11537 | 5.0% |
| o | 10997 | 4.8% |
| d | 9170 | 4.0% |
| t | 8291 | 3.6% |
| Other values (53) | 82725 |
brand
Categorical
High correlation  Imbalance 
| Distinct | 48 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
| Generic | |
|---|---|
| Determine | |
| Uni-Gold | 373 |
| Aluvia | 250 |
| Kaletra | 165 |
| Other values (43) |
Length
| Max length | 15 |
|---|---|
| Median length | 7 |
| Mean length | 7.2879698 |
| Min length | 3 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Reveal |
|---|---|
| 2nd row | Generic |
| 3rd row | Determine |
| 4th row | Generic |
| 5th row | Generic |
Common Values
| Value | Count | Frequency (%) |
| Generic | 7285 | |
| Determine | 799 | 7.7% |
| Uni-Gold | 373 | 3.6% |
| Aluvia | 250 | 2.4% |
| Kaletra | 165 | 1.6% |
| Norvir | 136 | 1.3% |
| Stat-Pak | 115 | 1.1% |
| Bioline | 113 | 1.1% |
| Truvada | 94 | 0.9% |
| Videx | 84 | 0.8% |
| Other values (38) | 910 | 8.8% |
Length
| Value | Count | Frequency (%) |
| generic | 7285 | |
| determine | 799 | 7.6% |
| uni-gold | 373 | 3.6% |
| aluvia | 250 | 2.4% |
| kaletra | 165 | 1.6% |
| norvir | 136 | 1.3% |
| videx | 125 | 1.2% |
| stat-pak | 115 | 1.1% |
| bioline | 113 | 1.1% |
| truvada | 94 | 0.9% |
| Other values (40) | 995 | 9.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 18044 | |
| i | 10118 | |
| r | 9288 | |
| n | 8958 | |
| G | 7758 | |
| c | 7463 | |
| t | 1628 | 2.2% |
| a | 1599 | 2.1% |
| l | 1331 | 1.8% |
| o | 991 | 1.3% |
| Other values (38) | 8063 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 75241 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 18044 | |
| i | 10118 | |
| r | 9288 | |
| n | 8958 | |
| G | 7758 | |
| c | 7463 | |
| t | 1628 | 2.2% |
| a | 1599 | 2.1% |
| l | 1331 | 1.8% |
| o | 991 | 1.3% |
| Other values (38) | 8063 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 75241 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 18044 | |
| i | 10118 | |
| r | 9288 | |
| n | 8958 | |
| G | 7758 | |
| c | 7463 | |
| t | 1628 | 2.2% |
| a | 1599 | 2.1% |
| l | 1331 | 1.8% |
| o | 991 | 1.3% |
| Other values (38) | 8063 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 75241 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 18044 | |
| i | 10118 | |
| r | 9288 | |
| n | 8958 | |
| G | 7758 | |
| c | 7463 | |
| t | 1628 | 2.2% |
| a | 1599 | 2.1% |
| l | 1331 | 1.8% |
| o | 991 | 1.3% |
| Other values (38) | 8063 |
dosage
Text
Missing 
| Distinct | 54 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 1736 |
| Missing (%) | 16.8% |
| Memory size | 80.8 KiB |
Length
| Max length | 15 |
|---|---|
| Median length | 13 |
| Mean length | 7.3544481 |
| Min length | 2 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 10mg/ml |
|---|---|
| 2nd row | 150mg |
| 3rd row | 30mg |
| 4th row | 10mg/ml |
| 5th row | 200mg |
| Value | Count | Frequency (%) |
| 300mg | 990 | 11.5% |
| 200mg | 932 | 10.9% |
| 600mg | 772 | 9.0% |
| 150/300mg | 600 | 7.0% |
| 150/300/200mg | 580 | 6.8% |
| 10mg/ml | 552 | 6.4% |
| 150mg | 431 | 5.0% |
| 200/50mg | 395 | 4.6% |
| 300/300mg | 301 | 3.5% |
| 600/300/300mg | 286 | 3.3% |
| Other values (44) | 2749 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 21765 | |
| m | 9548 | |
| g | 8596 | 13.6% |
| / | 6117 | 9.7% |
| 3 | 4855 | 7.7% |
| 2 | 3187 | 5.0% |
| 1 | 3098 | 4.9% |
| 5 | 3045 | 4.8% |
| 6 | 1613 | 2.6% |
| l | 964 | 1.5% |
| Other values (4) | 372 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 63160 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 21765 | |
| m | 9548 | |
| g | 8596 | 13.6% |
| / | 6117 | 9.7% |
| 3 | 4855 | 7.7% |
| 2 | 3187 | 5.0% |
| 1 | 3098 | 4.9% |
| 5 | 3045 | 4.8% |
| 6 | 1613 | 2.6% |
| l | 964 | 1.5% |
| Other values (4) | 372 | 0.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 63160 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 21765 | |
| m | 9548 | |
| g | 8596 | 13.6% |
| / | 6117 | 9.7% |
| 3 | 4855 | 7.7% |
| 2 | 3187 | 5.0% |
| 1 | 3098 | 4.9% |
| 5 | 3045 | 4.8% |
| 6 | 1613 | 2.6% |
| l | 964 | 1.5% |
| Other values (4) | 372 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 63160 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 21765 | |
| m | 9548 | |
| g | 8596 | 13.6% |
| / | 6117 | 9.7% |
| 3 | 4855 | 7.7% |
| 2 | 3187 | 5.0% |
| 1 | 3098 | 4.9% |
| 5 | 3045 | 4.8% |
| 6 | 1613 | 2.6% |
| l | 964 | 1.5% |
| Other values (4) | 372 | 0.6% |
dosage form
Categorical
High correlation 
| Distinct | 17 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
| Tablet | |
|---|---|
| Tablet - FDC | |
| Test kit | |
| Capsule | |
| Oral solution | |
| Other values (12) |
Length
| Max length | 34 |
|---|---|
| Median length | 33 |
| Mean length | 10.253584 |
| Min length | 6 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Test kit |
|---|---|
| 2nd row | Oral suspension |
| 3rd row | Test kit |
| 4th row | Tablet |
| 5th row | Capsule |
Common Values
| Value | Count | Frequency (%) |
| Tablet | 3532 | |
| Tablet - FDC | 2749 | |
| Test kit | 1575 | |
| Capsule | 729 | 7.1% |
| Oral solution | 727 | 7.0% |
| Chewable/dispersible tablet - FDC | 239 | 2.3% |
| Oral suspension | 214 | 2.1% |
| Test kit - Ancillary | 161 | 1.6% |
| Chewable/dispersible tablet | 146 | 1.4% |
| Delayed-release capsules | 131 | 1.3% |
| Other values (7) | 121 | 1.2% |
Length
| Value | Count | Frequency (%) |
| tablet | 6711 | |
| 3270 | ||
| fdc | 3023 | |
| test | 1736 | 8.6% |
| kit | 1736 | 8.6% |
| oral | 970 | 4.8% |
| solution | 755 | 3.7% |
| capsule | 729 | 3.6% |
| chewable/dispersible | 385 | 1.9% |
| suspension | 214 | 1.1% |
| Other values (8) | 654 | 3.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 12083 | |
| t | 11415 | |
| l | 10859 | |
| 9859 | ||
| a | 9472 | |
| T | 8062 | 7.6% |
| b | 7567 | 7.1% |
| s | 5234 | 4.9% |
| C | 4137 | 3.9% |
| i | 3728 | 3.5% |
| Other values (22) | 23442 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 105858 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 12083 | |
| t | 11415 | |
| l | 10859 | |
| 9859 | ||
| a | 9472 | |
| T | 8062 | 7.6% |
| b | 7567 | 7.1% |
| s | 5234 | 4.9% |
| C | 4137 | 3.9% |
| i | 3728 | 3.5% |
| Other values (22) | 23442 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 105858 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 12083 | |
| t | 11415 | |
| l | 10859 | |
| 9859 | ||
| a | 9472 | |
| T | 8062 | 7.6% |
| b | 7567 | 7.1% |
| s | 5234 | 4.9% |
| C | 4137 | 3.9% |
| i | 3728 | 3.5% |
| Other values (22) | 23442 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 105858 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 12083 | |
| t | 11415 | |
| l | 10859 | |
| 9859 | ||
| a | 9472 | |
| T | 8062 | 7.6% |
| b | 7567 | 7.1% |
| s | 5234 | 4.9% |
| C | 4137 | 3.9% |
| i | 3728 | 3.5% |
| Other values (22) | 23442 |
unit of measure (per pack)
Real number (ℝ)
High correlation 
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 77.990895 |
| Minimum | 1 |
|---|---|
| Maximum | 1000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 80.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 20 |
| Q1 | 30 |
| median | 60 |
| Q3 | 90 |
| 95-th percentile | 240 |
| Maximum | 1000 |
| Range | 999 |
| Interquartile range (IQR) | 60 |
Descriptive statistics
| Standard deviation | 76.579764 |
|---|---|
| Coefficient of variation (CV) | 0.98190646 |
| Kurtosis | 36.093999 |
| Mean | 77.990895 |
| Median Absolute Deviation (MAD) | 30 |
| Skewness | 4.3025025 |
| Sum | 805178 |
| Variance | 5864.4602 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 60 | 4121 | |
| 30 | 2630 | |
| 100 | 976 | 9.5% |
| 240 | 670 | 6.5% |
| 120 | 474 | 4.6% |
| 20 | 470 | 4.6% |
| 90 | 222 | 2.2% |
| 300 | 157 | 1.5% |
| 1 | 126 | 1.2% |
| 25 | 114 | 1.1% |
| Other values (21) | 364 | 3.5% |
| Value | Count | Frequency (%) |
| 1 | 126 | 1.2% |
| 2 | 4 | < 0.1% |
| 3 | 8 | 0.1% |
| 5 | 4 | < 0.1% |
| 12 | 2 | < 0.1% |
| 18 | 4 | < 0.1% |
| 20 | 470 | 4.6% |
| 24 | 2 | < 0.1% |
| 25 | 114 | 1.1% |
| 30 | 2630 |
| Value | Count | Frequency (%) |
| 1000 | 16 | 0.2% |
| 720 | 5 | < 0.1% |
| 540 | 7 | 0.1% |
| 336 | 39 | 0.4% |
| 300 | 157 | 1.5% |
| 270 | 53 | 0.5% |
| 240 | 670 | |
| 200 | 76 | 0.7% |
| 180 | 76 | 0.7% |
| 168 | 3 | < 0.1% |
line item quantity
Real number (ℝ)
High correlation 
| Distinct | 5065 |
|---|---|
| Distinct (%) | 49.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18332.535 |
| Minimum | 1 |
|---|---|
| Maximum | 619999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 80.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 408 |
| median | 3000 |
| Q3 | 17039.75 |
| 95-th percentile | 90951.55 |
| Maximum | 619999 |
| Range | 619998 |
| Interquartile range (IQR) | 16631.75 |
Descriptive statistics
| Standard deviation | 40035.303 |
|---|---|
| Coefficient of variation (CV) | 2.1838389 |
| Kurtosis | 40.0503 |
| Mean | 18332.535 |
| Median Absolute Deviation (MAD) | 2950 |
| Skewness | 5.0383147 |
| Sum | 1.8926509 × 108 |
| Variance | 1.6028255 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10000 | 93 | 0.9% |
| 1000 | 91 | 0.9% |
| 100 | 87 | 0.8% |
| 2000 | 73 | 0.7% |
| 5000 | 69 | 0.7% |
| 500 | 67 | 0.6% |
| 20000 | 67 | 0.6% |
| 3000 | 66 | 0.6% |
| 3 | 63 | 0.6% |
| 50000 | 62 | 0.6% |
| Other values (5055) | 9586 |
| Value | Count | Frequency (%) |
| 1 | 35 | |
| 2 | 40 | |
| 3 | 63 | |
| 4 | 46 | |
| 5 | 28 | |
| 6 | 48 | |
| 7 | 27 | |
| 8 | 26 | |
| 9 | 22 | 0.2% |
| 10 | 54 |
| Value | Count | Frequency (%) |
| 619999 | 1 | < 0.1% |
| 600906 | 1 | < 0.1% |
| 555197 | 1 | < 0.1% |
| 515000 | 3 | |
| 514526 | 1 | < 0.1% |
| 460041 | 1 | < 0.1% |
| 440000 | 1 | < 0.1% |
| 438409 | 1 | < 0.1% |
| 401961 | 1 | < 0.1% |
| 400000 | 2 |
line item value
Real number (ℝ)
High correlation 
| Distinct | 8741 |
|---|---|
| Distinct (%) | 84.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 157650.57 |
| Minimum | 0 |
|---|---|
| Maximum | 5951990.4 |
| Zeros | 17 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 80.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 192.5755 |
| Q1 | 4314.5925 |
| median | 30471.465 |
| Q3 | 166447.14 |
| 95-th percentile | 702831 |
| Maximum | 5951990.4 |
| Range | 5951990.4 |
| Interquartile range (IQR) | 162132.55 |
Descriptive statistics
| Standard deviation | 345292.07 |
|---|---|
| Coefficient of variation (CV) | 2.1902368 |
| Kurtosis | 54.15243 |
| Mean | 157650.57 |
| Median Absolute Deviation (MAD) | 29920.465 |
| Skewness | 5.8370202 |
| Sum | 1.6275845 × 109 |
| Variance | 1.1922661 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 200000 | 29 | 0.3% |
| 16000 | 23 | 0.2% |
| 800 | 18 | 0.2% |
| 0 | 17 | 0.2% |
| 14400 | 16 | 0.2% |
| 3200 | 15 | 0.1% |
| 244216 | 15 | 0.1% |
| 120000 | 13 | 0.1% |
| 160 | 11 | 0.1% |
| 250 | 11 | 0.1% |
| Other values (8731) | 10156 |
| Value | Count | Frequency (%) |
| 0 | 17 | |
| 0.01 | 1 | < 0.1% |
| 0.03 | 1 | < 0.1% |
| 0.12 | 1 | < 0.1% |
| 0.2 | 1 | < 0.1% |
| 0.24 | 1 | < 0.1% |
| 0.25 | 1 | < 0.1% |
| 0.42 | 1 | < 0.1% |
| 0.5 | 1 | < 0.1% |
| 0.7 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 5951990.4 | 1 | |
| 5768697.6 | 1 | |
| 5329891.2 | 1 | |
| 5140114.74 | 1 | |
| 4959241.98 | 1 | |
| 4278871.84 | 1 | |
| 4228629.72 | 1 | |
| 4014000 | 1 | |
| 3932880 | 1 | |
| 3904000 | 2 |
pack price
Real number (ℝ)
High correlation 
| Distinct | 1175 |
|---|---|
| Distinct (%) | 11.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.910241 |
| Minimum | 0 |
|---|---|
| Maximum | 1345.64 |
| Zeros | 18 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 80.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.9 |
| Q1 | 4.12 |
| median | 9.3 |
| Q3 | 23.5925 |
| 95-th percentile | 80 |
| Maximum | 1345.64 |
| Range | 1345.64 |
| Interquartile range (IQR) | 19.4725 |
Descriptive statistics
| Standard deviation | 45.609223 |
|---|---|
| Coefficient of variation (CV) | 2.0816395 |
| Kurtosis | 293.1762 |
| Mean | 21.910241 |
| Median Absolute Deviation (MAD) | 6.57 |
| Skewness | 12.988432 |
| Sum | 226201.33 |
| Variance | 2080.2012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 32 | 368 | 3.6% |
| 80 | 307 | 3.0% |
| 89 | 183 | 1.8% |
| 11.22 | 139 | 1.3% |
| 20 | 110 | 1.1% |
| 1.95 | 91 | 0.9% |
| 8.76 | 91 | 0.9% |
| 2.44 | 90 | 0.9% |
| 2.1 | 89 | 0.9% |
| 2.26 | 88 | 0.9% |
| Other values (1165) | 8768 |
| Value | Count | Frequency (%) |
| 0 | 18 | 0.2% |
| 0.01 | 85 | |
| 0.39 | 2 | < 0.1% |
| 0.7 | 2 | < 0.1% |
| 0.9 | 4 | < 0.1% |
| 1.1 | 2 | < 0.1% |
| 1.14 | 2 | < 0.1% |
| 1.17 | 1 | < 0.1% |
| 1.2 | 1 | < 0.1% |
| 1.21 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1345.64 | 1 | < 0.1% |
| 1250 | 1 | < 0.1% |
| 1242.53 | 3 | < 0.1% |
| 750.29 | 1 | < 0.1% |
| 700 | 1 | < 0.1% |
| 400 | 9 | 0.1% |
| 350 | 39 | |
| 308.17 | 3 | < 0.1% |
| 306.88 | 3 | < 0.1% |
| 301.53 | 1 | < 0.1% |
unit price
Real number (ℝ)
High correlation  Skewed 
| Distinct | 183 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.61170089 |
| Minimum | 0 |
|---|---|
| Maximum | 238.65 |
| Zeros | 103 |
| Zeros (%) | 1.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 80.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.01 |
| Q1 | 0.08 |
| median | 0.16 |
| Q3 | 0.47 |
| 95-th percentile | 1.6 |
| Maximum | 238.65 |
| Range | 238.65 |
| Interquartile range (IQR) | 0.39 |
Descriptive statistics
| Standard deviation | 3.2758077 |
|---|---|
| Coefficient of variation (CV) | 5.3552443 |
| Kurtosis | 2725.9603 |
| Mean | 0.61170089 |
| Median Absolute Deviation (MAD) | 0.12 |
| Skewness | 40.584849 |
| Sum | 6315.2 |
| Variance | 10.730916 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.04 | 713 | 6.9% |
| 0.01 | 492 | 4.8% |
| 0.12 | 464 | 4.5% |
| 0.14 | 444 | 4.3% |
| 0.8 | 411 | 4.0% |
| 0.11 | 400 | 3.9% |
| 1.6 | 368 | 3.6% |
| 0.05 | 343 | 3.3% |
| 0.16 | 343 | 3.3% |
| 0.19 | 321 | 3.1% |
| Other values (173) | 6025 |
| Value | Count | Frequency (%) |
| 0 | 103 | 1.0% |
| 0.01 | 492 | |
| 0.02 | 140 | 1.4% |
| 0.03 | 250 | 2.4% |
| 0.04 | 713 | |
| 0.05 | 343 | |
| 0.06 | 274 | 2.7% |
| 0.07 | 248 | 2.4% |
| 0.08 | 146 | 1.4% |
| 0.09 | 154 | 1.5% |
| Value | Count | Frequency (%) |
| 238.65 | 1 | < 0.1% |
| 41.68 | 1 | < 0.1% |
| 37.5 | 2 | < 0.1% |
| 30 | 1 | < 0.1% |
| 26.91 | 1 | < 0.1% |
| 25 | 4 | < 0.1% |
| 24.85 | 3 | < 0.1% |
| 24.5 | 46 | |
| 23 | 23 | |
| 17.12 | 3 | < 0.1% |
| Distinct | 88 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
Length
| Max length | 72 |
|---|---|
| Median length | 37 |
| Mean length | 25.039132 |
| Min length | 5 |
Unique
| Unique | 16 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | Ranbaxy Fine Chemicals LTD |
|---|---|
| 2nd row | Aurobindo Unit III, India |
| 3rd row | ABBVIE GmbH & Co.KG Wiesbaden |
| 4th row | Ranbaxy, Paonta Shahib, India |
| 5th row | Aurobindo Unit III, India |
| Value | Count | Frequency (%) |
| india | 4678 | 11.9% |
| unit | 4197 | 10.7% |
| iii | 4041 | 10.3% |
| aurobindo | 3283 | 8.4% |
| mylan | 1438 | 3.7% |
| formerly | 1415 | 3.6% |
| matrix | 1415 | 3.6% |
| nashik | 1415 | 3.6% |
| in | 1047 | 2.7% |
| hetero | 913 | 2.3% |
| Other values (201) | 15396 |
Most occurring characters
| Value | Count | Frequency (%) |
| 28937 | 11.2% | |
| i | 20789 | 8.0% |
| I | 19607 | 7.6% |
| a | 18921 | 7.3% |
| n | 18236 | 7.1% |
| r | 13636 | 5.3% |
| o | 12958 | 5.0% |
| d | 12314 | 4.8% |
| e | 10570 | 4.1% |
| t | 10195 | 3.9% |
| Other values (59) | 92341 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 258504 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 28937 | 11.2% | |
| i | 20789 | 8.0% |
| I | 19607 | 7.6% |
| a | 18921 | 7.3% |
| n | 18236 | 7.1% |
| r | 13636 | 5.3% |
| o | 12958 | 5.0% |
| d | 12314 | 4.8% |
| e | 10570 | 4.1% |
| t | 10195 | 3.9% |
| Other values (59) | 92341 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 258504 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 28937 | 11.2% | |
| i | 20789 | 8.0% |
| I | 19607 | 7.6% |
| a | 18921 | 7.3% |
| n | 18236 | 7.1% |
| r | 13636 | 5.3% |
| o | 12958 | 5.0% |
| d | 12314 | 4.8% |
| e | 10570 | 4.1% |
| t | 10195 | 3.9% |
| Other values (59) | 92341 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 258504 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 28937 | 11.2% | |
| i | 20789 | 8.0% |
| I | 19607 | 7.6% |
| a | 18921 | 7.3% |
| n | 18236 | 7.1% |
| r | 13636 | 5.3% |
| o | 12958 | 5.0% |
| d | 12314 | 4.8% |
| e | 10570 | 4.1% |
| t | 10195 | 3.9% |
| Other values (59) | 92341 |
first line designation
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.2 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 7030 | |
| False | 3294 |
| Distinct | 4688 |
|---|---|
| Distinct (%) | 45.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
Length
| Max length | 26 |
|---|---|
| Median length | 24 |
| Mean length | 11.359163 |
| Min length | 1 |
Unique
| Unique | 3014 ? |
|---|---|
| Unique (%) | 29.2% |
Sample
| 1st row | 13 |
|---|---|
| 2nd row | 358 |
| 3rd row | 171 |
| 4th row | 1855 |
| 5th row | 7590 |
| Value | Count | Frequency (%) |
| see | 2445 | 13.4% |
| weight | 1507 | 8.3% |
| separately | 1507 | 8.3% |
| captured | 1507 | 8.3% |
| 2 | 29 | 0.2% |
| 6 | 26 | 0.1% |
| 1 | 23 | 0.1% |
| 5 | 20 | 0.1% |
| 60 | 20 | 0.1% |
| 4 | 19 | 0.1% |
| Other values (5980) | 11125 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 10918 | 9.3% |
| 7904 | 6.7% | |
| 1 | 6455 | 5.5% |
| 2 | 5833 | 5.0% |
| 3 | 5113 | 4.4% |
| 8 | 4534 | 3.9% |
| t | 4521 | 3.9% |
| a | 4521 | 3.9% |
| S | 4460 | 3.8% |
| D | 4382 | 3.7% |
| Other values (25) | 58631 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 117272 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 10918 | 9.3% |
| 7904 | 6.7% | |
| 1 | 6455 | 5.5% |
| 2 | 5833 | 5.0% |
| 3 | 5113 | 4.4% |
| 8 | 4534 | 3.9% |
| t | 4521 | 3.9% |
| a | 4521 | 3.9% |
| S | 4460 | 3.8% |
| D | 4382 | 3.7% |
| Other values (25) | 58631 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 117272 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 10918 | 9.3% |
| 7904 | 6.7% | |
| 1 | 6455 | 5.5% |
| 2 | 5833 | 5.0% |
| 3 | 5113 | 4.4% |
| 8 | 4534 | 3.9% |
| t | 4521 | 3.9% |
| a | 4521 | 3.9% |
| S | 4460 | 3.8% |
| D | 4382 | 3.7% |
| Other values (25) | 58631 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 117272 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 10918 | 9.3% |
| 7904 | 6.7% | |
| 1 | 6455 | 5.5% |
| 2 | 5833 | 5.0% |
| 3 | 5113 | 4.4% |
| 8 | 4534 | 3.9% |
| t | 4521 | 3.9% |
| a | 4521 | 3.9% |
| S | 4460 | 3.8% |
| D | 4382 | 3.7% |
| Other values (25) | 58631 |
| Distinct | 6733 |
|---|---|
| Distinct (%) | 65.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 80.8 KiB |
Length
| Max length | 34 |
|---|---|
| Median length | 24 |
| Mean length | 14.795234 |
| Min length | 2 |
Unique
| Unique | 5849 ? |
|---|---|
| Unique (%) | 56.7% |
Sample
| 1st row | 780.34 |
|---|---|
| 2nd row | 4521.5 |
| 3rd row | 1653.78 |
| 4th row | 16007.06 |
| 5th row | 45450.08 |
| Value | Count | Frequency (%) |
| see | 2445 | 11.5% |
| freight | 1442 | 6.8% |
| in | 1442 | 6.8% |
| commodity | 1442 | 6.8% |
| cost | 1442 | 6.8% |
| included | 1442 | 6.8% |
| invoiced | 239 | 1.1% |
| separately | 239 | 1.1% |
| 9736.1 | 36 | 0.2% |
| 6147.18 | 27 | 0.1% |
| Other values (8028) | 11025 |
Most occurring characters
| Value | Count | Frequency (%) |
| 10897 | 7.1% | |
| e | 8491 | 5.6% |
| 1 | 8391 | 5.5% |
| 2 | 7344 | 4.8% |
| 3 | 6673 | 4.4% |
| 8 | 6162 | 4.0% |
| . | 5734 | 3.8% |
| 4 | 5646 | 3.7% |
| 5 | 5346 | 3.5% |
| 6 | 5136 | 3.4% |
| Other values (32) | 82926 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 152746 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 10897 | 7.1% | |
| e | 8491 | 5.6% |
| 1 | 8391 | 5.5% |
| 2 | 7344 | 4.8% |
| 3 | 6673 | 4.4% |
| 8 | 6162 | 4.0% |
| . | 5734 | 3.8% |
| 4 | 5646 | 3.7% |
| 5 | 5346 | 3.5% |
| 6 | 5136 | 3.4% |
| Other values (32) | 82926 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 152746 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 10897 | 7.1% | |
| e | 8491 | 5.6% |
| 1 | 8391 | 5.5% |
| 2 | 7344 | 4.8% |
| 3 | 6673 | 4.4% |
| 8 | 6162 | 4.0% |
| . | 5734 | 3.8% |
| 4 | 5646 | 3.7% |
| 5 | 5346 | 3.5% |
| 6 | 5136 | 3.4% |
| Other values (32) | 82926 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 152746 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 10897 | 7.1% | |
| e | 8491 | 5.6% |
| 1 | 8391 | 5.5% |
| 2 | 7344 | 4.8% |
| 3 | 6673 | 4.4% |
| 8 | 6162 | 4.0% |
| . | 5734 | 3.8% |
| 4 | 5646 | 3.7% |
| 5 | 5346 | 3.5% |
| 6 | 5136 | 3.4% |
| Other values (32) | 82926 |
line item insurance (usd)
Real number (ℝ)
High correlation  Missing 
| Distinct | 6722 |
|---|---|
| Distinct (%) | 67.0% |
| Missing | 287 |
| Missing (%) | 2.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 240.11763 |
| Minimum | 0 |
|---|---|
| Maximum | 7708.44 |
| Zeros | 54 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 80.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.25 |
| Q1 | 6.51 |
| median | 47.04 |
| Q3 | 252.4 |
| 95-th percentile | 1082.032 |
| Maximum | 7708.44 |
| Range | 7708.44 |
| Interquartile range (IQR) | 245.89 |
Descriptive statistics
| Standard deviation | 500.19057 |
|---|---|
| Coefficient of variation (CV) | 2.0831064 |
| Kurtosis | 34.911215 |
| Mean | 240.11763 |
| Median Absolute Deviation (MAD) | 46.27 |
| Skewness | 4.8271624 |
| Sum | 2410060.6 |
| Variance | 250190.6 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 54 | 0.5% |
| 0.02 | 37 | 0.4% |
| 0.07 | 33 | 0.3% |
| 0.05 | 30 | 0.3% |
| 0.06 | 30 | 0.3% |
| 0.01 | 26 | 0.3% |
| 0.03 | 23 | 0.2% |
| 0.09 | 21 | 0.2% |
| 0.08 | 20 | 0.2% |
| 0.49 | 18 | 0.2% |
| Other values (6712) | 9745 | |
| (Missing) | 287 | 2.8% |
| Value | Count | Frequency (%) |
| 0 | 54 | |
| 0.01 | 26 | |
| 0.02 | 37 | |
| 0.03 | 23 | |
| 0.04 | 14 | 0.1% |
| 0.05 | 30 | |
| 0.06 | 30 | |
| 0.07 | 33 | |
| 0.08 | 20 | 0.2% |
| 0.09 | 21 | 0.2% |
| Value | Count | Frequency (%) |
| 7708.44 | 1 | |
| 7005.49 | 1 | |
| 5930.22 | 1 | |
| 5573.31 | 1 | |
| 5479.13 | 1 | |
| 5284.04 | 1 | |
| 5230.81 | 1 | |
| 5162.29 | 1 | |
| 5145 | 2 | |
| 5098.1 | 1 |
Interactions
Correlations
| id | unit of measure (per pack) | line item quantity | line item value | pack price | unit price | line item insurance (usd) | |
|---|---|---|---|---|---|---|---|
| id | 1.000 | -0.083 | 0.192 | 0.136 | -0.169 | -0.073 | 0.104 |
| unit of measure (per pack) | -0.083 | 1.000 | -0.151 | -0.129 | 0.097 | -0.103 | -0.132 |
| line item quantity | 0.192 | -0.151 | 1.000 | 0.839 | -0.134 | -0.052 | 0.799 |
| line item value | 0.136 | -0.129 | 0.839 | 1.000 | -0.019 | -0.020 | 0.961 |
| pack price | -0.169 | 0.097 | -0.134 | -0.019 | 1.000 | 0.250 | -0.015 |
| unit price | -0.073 | -0.103 | -0.052 | -0.020 | 0.250 | 1.000 | -0.021 |
| line item insurance (usd) | 0.104 | -0.132 | 0.799 | 0.961 | -0.015 | -0.021 | 1.000 |
| id | unit of measure (per pack) | line item quantity | line item value | pack price | unit price | line item insurance (usd) | |
|---|---|---|---|---|---|---|---|
| id | 1.000 | -0.057 | 0.265 | 0.143 | -0.280 | -0.224 | 0.124 |
| unit of measure (per pack) | -0.057 | 1.000 | -0.186 | -0.140 | 0.054 | -0.387 | -0.134 |
| line item quantity | 0.265 | -0.186 | 1.000 | 0.877 | -0.330 | -0.200 | 0.874 |
| line item value | 0.143 | -0.140 | 0.877 | 1.000 | 0.131 | 0.200 | 0.995 |
| pack price | -0.280 | 0.054 | -0.330 | 0.131 | 1.000 | 0.859 | 0.132 |
| unit price | -0.224 | -0.387 | -0.200 | 0.200 | 0.859 | 1.000 | 0.200 |
| line item insurance (usd) | 0.124 | -0.134 | 0.874 | 0.995 | 0.132 | 0.200 | 1.000 |
| brand | country | dosage form | first line designation | fulfill via | id | line item insurance (usd) | line item quantity | line item value | managed by | pack price | product group | shipment mode | sub classification | unit of measure (per pack) | unit price | vendor inco term | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| brand | 1.000 | 0.199 | 0.515 | 0.245 | 0.507 | 0.206 | 0.023 | 0.000 | 0.000 | 0.163 | 0.796 | 0.781 | 0.216 | 0.647 | 0.587 | 0.911 | 0.443 |
| country | 0.199 | 1.000 | 0.194 | 0.321 | 0.610 | 0.205 | 0.091 | 0.062 | 0.073 | 0.098 | 0.181 | 0.313 | 0.548 | 0.310 | 0.154 | 0.121 | 0.441 |
| dosage form | 0.515 | 0.194 | 1.000 | 0.230 | 0.476 | 0.171 | 0.093 | 0.081 | 0.089 | 0.019 | 0.095 | 0.653 | 0.239 | 0.825 | 0.546 | 0.126 | 0.288 |
| first line designation | 0.245 | 0.321 | 0.230 | 1.000 | 0.099 | 0.110 | 0.072 | 0.032 | 0.050 | 0.099 | 0.066 | 0.192 | 0.241 | 0.207 | 0.036 | 0.050 | 0.309 |
| fulfill via | 0.507 | 0.610 | 0.476 | 0.099 | 1.000 | 0.884 | 0.118 | 0.137 | 0.128 | 0.078 | 0.081 | 0.385 | 0.380 | 0.394 | 0.058 | 0.078 | 1.000 |
| id | 0.206 | 0.205 | 0.171 | 0.110 | 0.884 | 1.000 | 0.124 | 0.265 | 0.143 | 0.067 | -0.280 | 0.187 | 0.261 | 0.170 | -0.057 | -0.224 | 0.338 |
| line item insurance (usd) | 0.023 | 0.091 | 0.093 | 0.072 | 0.118 | 0.124 | 1.000 | 0.874 | 0.995 | 0.000 | 0.132 | 0.023 | 0.149 | 0.073 | -0.134 | 0.200 | 0.040 |
| line item quantity | 0.000 | 0.062 | 0.081 | 0.032 | 0.137 | 0.265 | 0.874 | 1.000 | 0.877 | 0.000 | -0.330 | 0.062 | 0.197 | 0.088 | -0.186 | -0.200 | 0.054 |
| line item value | 0.000 | 0.073 | 0.089 | 0.050 | 0.128 | 0.143 | 0.995 | 0.877 | 1.000 | 0.000 | 0.131 | 0.018 | 0.135 | 0.062 | -0.140 | 0.200 | 0.042 |
| managed by | 0.163 | 0.098 | 0.019 | 0.099 | 0.078 | 0.067 | 0.000 | 0.000 | 0.000 | 1.000 | 0.075 | 0.018 | 0.068 | 0.018 | 0.000 | 0.000 | 0.105 |
| pack price | 0.796 | 0.181 | 0.095 | 0.066 | 0.081 | -0.280 | 0.132 | -0.330 | 0.131 | 0.075 | 1.000 | 0.094 | 0.039 | 0.099 | 0.054 | 0.859 | 0.069 |
| product group | 0.781 | 0.313 | 0.653 | 0.192 | 0.385 | 0.187 | 0.023 | 0.062 | 0.018 | 0.018 | 0.094 | 1.000 | 0.192 | 0.866 | 0.615 | 0.118 | 0.322 |
| shipment mode | 0.216 | 0.548 | 0.239 | 0.241 | 0.380 | 0.261 | 0.149 | 0.197 | 0.135 | 0.068 | 0.039 | 0.192 | 1.000 | 0.200 | 0.058 | 0.058 | 0.380 |
| sub classification | 0.647 | 0.310 | 0.825 | 0.207 | 0.394 | 0.170 | 0.073 | 0.088 | 0.062 | 0.018 | 0.099 | 0.866 | 0.200 | 1.000 | 0.573 | 0.130 | 0.284 |
| unit of measure (per pack) | 0.587 | 0.154 | 0.546 | 0.036 | 0.058 | -0.057 | -0.134 | -0.186 | -0.140 | 0.000 | 0.054 | 0.615 | 0.058 | 0.573 | 1.000 | -0.387 | 0.159 |
| unit price | 0.911 | 0.121 | 0.126 | 0.050 | 0.078 | -0.224 | 0.200 | -0.200 | 0.200 | 0.000 | 0.859 | 0.118 | 0.058 | 0.130 | -0.387 | 1.000 | 0.072 |
| vendor inco term | 0.443 | 0.441 | 0.288 | 0.309 | 1.000 | 0.338 | 0.040 | 0.054 | 0.042 | 0.105 | 0.069 | 0.322 | 0.380 | 0.284 | 0.159 | 0.072 | 1.000 |
Missing values
Sample
| id | project code | pq # | po / so # | asn/dn # | country | managed by | fulfill via | vendor inco term | shipment mode | pq first sent to client date | po sent to vendor date | scheduled delivery date | delivered to client date | delivery recorded date | product group | sub classification | vendor | item description | molecule/test type | brand | dosage | dosage form | unit of measure (per pack) | line item quantity | line item value | pack price | unit price | manufacturing site | first line designation | weight (kilograms) | freight cost (usd) | line item insurance (usd) | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 100-CI-T01 | Pre-PQ Process | SCMS-4 | ASN-8 | Côte d'Ivoire | PMO - US | Direct Drop | EXW | Air | Pre-PQ Process | Date Not Captured | 2-Jun-06 | 2-Jun-06 | 2-Jun-06 | HRDT | HIV test | RANBAXY Fine Chemicals LTD. | HIV, Reveal G3 Rapid HIV-1 Antibody Test, 30 Tests | HIV, Reveal G3 Rapid HIV-1 Antibody Test | Reveal | NaN | Test kit | 30 | 19 | 551.00 | 29.00 | 0.97 | Ranbaxy Fine Chemicals LTD | True | 13 | 780.34 | NaN |
| 1 | 3 | 108-VN-T01 | Pre-PQ Process | SCMS-13 | ASN-85 | Vietnam | PMO - US | Direct Drop | EXW | Air | Pre-PQ Process | Date Not Captured | 14-Nov-06 | 14-Nov-06 | 14-Nov-06 | ARV | Pediatric | Aurobindo Pharma Limited | Nevirapine 10mg/ml, oral suspension, Bottle, 240 ml | Nevirapine | Generic | 10mg/ml | Oral suspension | 240 | 1000 | 6200.00 | 6.20 | 0.03 | Aurobindo Unit III, India | True | 358 | 4521.5 | NaN |
| 2 | 4 | 100-CI-T01 | Pre-PQ Process | SCMS-20 | ASN-14 | Côte d'Ivoire | PMO - US | Direct Drop | FCA | Air | Pre-PQ Process | Date Not Captured | 27-Aug-06 | 27-Aug-06 | 27-Aug-06 | HRDT | HIV test | Abbott GmbH & Co. KG | HIV 1/2, Determine Complete HIV Kit, 100 Tests | HIV 1/2, Determine Complete HIV Kit | Determine | NaN | Test kit | 100 | 500 | 40000.00 | 80.00 | 0.80 | ABBVIE GmbH & Co.KG Wiesbaden | True | 171 | 1653.78 | NaN |
| 3 | 15 | 108-VN-T01 | Pre-PQ Process | SCMS-78 | ASN-50 | Vietnam | PMO - US | Direct Drop | EXW | Air | Pre-PQ Process | Date Not Captured | 1-Sep-06 | 1-Sep-06 | 1-Sep-06 | ARV | Adult | SUN PHARMACEUTICAL INDUSTRIES LTD (RANBAXY LABORATORIES LIMITED) | Lamivudine 150mg, tablets, 60 Tabs | Lamivudine | Generic | 150mg | Tablet | 60 | 31920 | 127360.80 | 3.99 | 0.07 | Ranbaxy, Paonta Shahib, India | True | 1855 | 16007.06 | NaN |
| 4 | 16 | 108-VN-T01 | Pre-PQ Process | SCMS-81 | ASN-55 | Vietnam | PMO - US | Direct Drop | EXW | Air | Pre-PQ Process | Date Not Captured | 11-Aug-06 | 11-Aug-06 | 11-Aug-06 | ARV | Adult | Aurobindo Pharma Limited | Stavudine 30mg, capsules, 60 Caps | Stavudine | Generic | 30mg | Capsule | 60 | 38000 | 121600.00 | 3.20 | 0.05 | Aurobindo Unit III, India | True | 7590 | 45450.08 | NaN |
| 5 | 23 | 112-NG-T01 | Pre-PQ Process | SCMS-87 | ASN-57 | Nigeria | PMO - US | Direct Drop | EXW | Air | Pre-PQ Process | Date Not Captured | 28-Sep-06 | 28-Sep-06 | 28-Sep-06 | ARV | Pediatric | Aurobindo Pharma Limited | Zidovudine 10mg/ml, oral solution, Bottle, 240 ml | Zidovudine | Generic | 10mg/ml | Oral solution | 240 | 416 | 2225.60 | 5.35 | 0.02 | Aurobindo Unit III, India | True | 504 | 5920.42 | NaN |
| 6 | 44 | 110-ZM-T01 | Pre-PQ Process | SCMS-139 | ASN-130 | Zambia | PMO - US | Direct Drop | DDU | Air | Pre-PQ Process | Date Not Captured | 8-Jan-07 | 8-Jan-07 | 8-Jan-07 | ARV | Pediatric | MERCK SHARP & DOHME IDEA GMBH (FORMALLY MERCK SHARP & DOHME B.V.) | Efavirenz 200mg [Stocrin/Sustiva], capsule, 90 Caps | Efavirenz | Stocrin/Sustiva | 200mg | Capsule | 90 | 135 | 4374.00 | 32.40 | 0.36 | MSD South Granville Australia | True | 328 | Freight Included in Commodity Cost | NaN |
| 7 | 45 | 109-TZ-T01 | Pre-PQ Process | SCMS-140 | ASN-94 | Tanzania | PMO - US | Direct Drop | EXW | Air | Pre-PQ Process | Date Not Captured | 24-Nov-06 | 24-Nov-06 | 24-Nov-06 | ARV | Adult | Aurobindo Pharma Limited | Nevirapine 200mg, tablets, 60 Tabs | Nevirapine | Generic | 200mg | Tablet | 60 | 16667 | 60834.55 | 3.65 | 0.06 | Aurobindo Unit III, India | True | 1478 | 6212.41 | NaN |
| 8 | 46 | 112-NG-T01 | Pre-PQ Process | SCMS-156 | ASN-93 | Nigeria | PMO - US | Direct Drop | EXW | Air | Pre-PQ Process | Date Not Captured | 7-Dec-06 | 7-Dec-06 | 7-Dec-06 | ARV | Adult | Aurobindo Pharma Limited | Stavudine 30mg, capsules, 60 Caps | Stavudine | Generic | 30mg | Capsule | 60 | 273 | 532.35 | 1.95 | 0.03 | Aurobindo Unit III, India | False | See ASN-93 (ID#:1281) | See ASN-93 (ID#:1281) | NaN |
| 9 | 47 | 110-ZM-T01 | Pre-PQ Process | SCMS-165 | ASN-199 | Zambia | PMO - US | Direct Drop | CIP | Air | Pre-PQ Process | 11/13/2006 | 30-Jan-07 | 30-Jan-07 | 30-Jan-07 | ARV | Adult | ABBVIE LOGISTICS (FORMERLY ABBOTT LOGISTICS BV) | Lopinavir/Ritonavir 200/50mg [Aluvia], tablets, 120 Tabs | Lopinavir/Ritonavir | Aluvia | 200/50mg | Tablet | 120 | 2800 | 115080.00 | 41.10 | 0.34 | ABBVIE (Abbott) St. P'burg USA | True | 643 | Freight Included in Commodity Cost | NaN |
| id | project code | pq # | po / so # | asn/dn # | country | managed by | fulfill via | vendor inco term | shipment mode | pq first sent to client date | po sent to vendor date | scheduled delivery date | delivered to client date | delivery recorded date | product group | sub classification | vendor | item description | molecule/test type | brand | dosage | dosage form | unit of measure (per pack) | line item quantity | line item value | pack price | unit price | manufacturing site | first line designation | weight (kilograms) | freight cost (usd) | line item insurance (usd) | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10314 | 86813 | 151-NG-T30 | FPQ-14989 | SO-51422 | DN-4274 | Nigeria | PMO - US | From RDC | N/A - From RDC | Air Charter | 9/19/2014 | N/A - From RDC | 30-Jun-15 | 15-May-15 | 22-May-15 | ARV | Pediatric | SCMS from RDC | Lamivudine/Nevirapine/Zidovudine 30/50/60mg, dispersible tablets, 60 Tabs | Lamivudine/Nevirapine/Zidovudine | Generic | 30/50/60mg | Chewable/dispersible tablet - FDC | 60 | 10340 | 37224.00 | 3.60 | 0.06 | Mylan (formerly Matrix) Nashik | False | See DN-4274 (ID#:84472) | See DN-4274 (ID#:84472) | 38.27 |
| 10315 | 86814 | 151-NG-T30 | FPQ-14989 | SO-51424 | DN-4276 | Nigeria | PMO - US | From RDC | N/A - From RDC | Air Charter | 9/19/2014 | N/A - From RDC | 30-Jun-15 | 15-May-15 | 22-May-15 | ARV | Adult | SCMS from RDC | Lopinavir/Ritonavir 200/50mg [Aluvia], tablets, 120 Tabs | Lopinavir/Ritonavir | Aluvia | 200/50mg | Tablet | 120 | 70000 | 1304800.00 | 18.64 | 0.16 | ABBVIE Ludwigshafen Germany | True | 15198 | 26180 | 1341.33 |
| 10316 | 86815 | 151-NG-T30 | FPQ-16313 | SO-51420 | DN-4279 | Nigeria | PMO - US | From RDC | N/A - From RDC | Air Charter | 5/4/2015 | N/A - From RDC | 2-Jun-15 | 15-May-15 | 22-May-15 | ARV | Adult | SCMS from RDC | Lamivudine/Zidovudine 150/300mg, tablets, 60 Tabs | Lamivudine/Zidovudine | Generic | 150/300mg | Tablet - FDC | 60 | 15000 | 97800.00 | 6.52 | 0.11 | Aurobindo Unit III, India | True | 1547 | 3410 | 115.11 |
| 10317 | 86816 | 151-NG-T30 | FPQ-16313 | SO-51440 | DN-4282 | Nigeria | PMO - US | From RDC | N/A - From RDC | Air | 5/4/2015 | N/A - From RDC | 30-Jun-15 | 22-Jun-15 | 29-Jun-15 | ARV | Adult | SCMS from RDC | Efavirenz 600mg, tablets, 30 Tabs | Efavirenz | Generic | 600mg | Tablet | 30 | 6724 | 20978.88 | 3.12 | 0.10 | Strides, Bangalore, India. | False | See DN-4282 (ID#:83919) | See DN-4282 (ID#:83919) | 24.69 |
| 10318 | 86817 | 103-ZW-T30 | FPQ-15197 | SO-50020 | DN-4307 | Zimbabwe | PMO - US | From RDC | N/A - From RDC | Truck | 10/16/2014 | N/A - From RDC | 31-Jul-15 | 15-Jul-15 | 20-Jul-15 | ARV | Pediatric | SCMS from RDC | Lamivudine/Nevirapine/Zidovudine 30/50/60mg, dispersible tablets, 60 Tabs | Lamivudine/Nevirapine/Zidovudine | Generic | 30/50/60mg | Chewable/dispersible tablet - FDC | 60 | 205243 | 738874.80 | 3.60 | 0.06 | Cipla, Goa, India | False | See DN-4307 (ID#:83920) | See DN-4307 (ID#:83920) | 869.66 |
| 10319 | 86818 | 103-ZW-T30 | FPQ-15197 | SO-50020 | DN-4307 | Zimbabwe | PMO - US | From RDC | N/A - From RDC | Truck | 10/16/2014 | N/A - From RDC | 31-Jul-15 | 15-Jul-15 | 20-Jul-15 | ARV | Pediatric | SCMS from RDC | Lamivudine/Nevirapine/Zidovudine 30/50/60mg, dispersible tablets, 60 Tabs | Lamivudine/Nevirapine/Zidovudine | Generic | 30/50/60mg | Chewable/dispersible tablet - FDC | 60 | 166571 | 599655.60 | 3.60 | 0.06 | Mylan, H-12 & H-13, India | False | See DN-4307 (ID#:83920) | See DN-4307 (ID#:83920) | 705.79 |
| 10320 | 86819 | 104-CI-T30 | FPQ-15259 | SO-50102 | DN-4313 | Côte d'Ivoire | PMO - US | From RDC | N/A - From RDC | Truck | 10/24/2014 | N/A - From RDC | 31-Jul-15 | 6-Aug-15 | 7-Aug-15 | ARV | Adult | SCMS from RDC | Lamivudine/Zidovudine 150/300mg, tablets, 60 Tabs | Lamivudine/Zidovudine | Generic | 150/300mg | Tablet - FDC | 60 | 21072 | 137389.44 | 6.52 | 0.11 | Hetero Unit III Hyderabad IN | False | See DN-4313 (ID#:83921) | See DN-4313 (ID#:83921) | 161.71 |
| 10321 | 86821 | 110-ZM-T30 | FPQ-14784 | SO-49600 | DN-4316 | Zambia | PMO - US | From RDC | N/A - From RDC | Truck | 8/12/2014 | N/A - From RDC | 31-Aug-15 | 25-Aug-15 | 3-Sep-15 | ARV | Adult | SCMS from RDC | Efavirenz/Lamivudine/Tenofovir Disoproxil Fumarate 600/300/300mg, tablets, 30 Tabs | Efavirenz/Lamivudine/Tenofovir Disoproxil Fumarate | Generic | 600/300/300mg | Tablet - FDC | 30 | 514526 | 5140114.74 | 9.99 | 0.33 | Cipla Ltd A-42 MIDC Mahar. IN | False | Weight Captured Separately | Freight Included in Commodity Cost | 5284.04 |
| 10322 | 86822 | 200-ZW-T30 | FPQ-16523 | SO-51680 | DN-4334 | Zimbabwe | PMO - US | From RDC | N/A - From RDC | Truck | 7/1/2015 | N/A - From RDC | 9-Sep-15 | 4-Aug-15 | 11-Aug-15 | ARV | Adult | SCMS from RDC | Lamivudine/Zidovudine 150/300mg, tablets, 60 Tabs | Lamivudine/Zidovudine | Generic | 150/300mg | Tablet - FDC | 60 | 17465 | 113871.80 | 6.52 | 0.11 | Mylan (formerly Matrix) Nashik | True | 1392 | Freight Included in Commodity Cost | 134.03 |
| 10323 | 86823 | 103-ZW-T30 | FPQ-15197 | SO-50022 | DN-4336 | Zimbabwe | PMO - US | From RDC | N/A - From RDC | Truck | 10/16/2014 | N/A - From RDC | 31-Aug-15 | 4-Aug-15 | 11-Aug-15 | ARV | Pediatric | SCMS from RDC | Lamivudine/Zidovudine 30/60mg, dispersible tablets, 60 Tabs | Lamivudine/Zidovudine | Generic | 30/60mg | Chewable/dispersible tablet - FDC | 60 | 36639 | 72911.61 | 1.99 | 0.03 | Cipla, Goa, India | False | Weight Captured Separately | Freight Included in Commodity Cost | 85.82 |